home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Templates / Business / Equipment Rental & Usage (.txt) < prev    next >
FileMaker Pro Database  |  1996-01-25  |  112KB  |  746 lines
  1. LZBovm9agm1cA/u3U499+TyGGjXtQpWvx4lnxg6ufZIoQqA6K0c8Q8Pz2HpNpRLFxycKpi588JJx
  2. 7R4BkCDMsLKet4DH78hwiyUWEtPHkXkyCRYyiDuoUhc2yVA0yw6O+CtcaC8UNVAksQLGpleEYDF1
  3. nAiI4NBf88fiZfWmmBUZsdqGWnjPyGAykmnJc6SGjDwyKsmXfDIsPa1tVf8g7vRNLuOGJ5rgkFTF
  4. SAv95J0mF/7DvFhR7nqYqXBMoy01w8kGsfooJXgYHA5hLFZRws7UaLzBUBWzwGE0iplCGpsuAHks
  5. 6j/zx6pGprO/UUOIvFB+SpChyw2/rMCwT944j/TQUdJixmo54LESNU0KwzgdBnFRE86E0uaLRqJE
  6. Yj+1mN1sHETucnhS1RP305ylocKgPVKPmeiwAo9q1LhJHmx6cUQUm+5QeomZvJPjRAN4/g5nmtHR
  7. dwqcMJLnLCB42QUFDWDn5xWIc7z
  8. HBAM2016AUG95
  9. Pro 3.0
  10. Sort by Date
  11. Sort by Project
  12. 'Sort f
  13. HBAM3016AUG95
  14. Pro 2.0 - 2.1F!
  15. Pro 3.0
  16.     Franz App
  17. ASSET ID
  18. CATEGORY
  19. CREATED BY
  20. CUSTOMER ORDER NUM
  21. DATE CREATED
  22. DATE DUE
  23. DATE DUE CALC
  24. DATE END
  25. DATE END CALC
  26. DATE MODIFIED
  27. DATE START
  28. DATE START CALC
  29. DAYS OVERDUE
  30. DAYS RENTED
  31. DON'T COUNT WKNDS
  32.     RECORD ID
  33. SERIAL NUMBER
  34. TODAY CALC
  35. TOTAL DAYS RENTED
  36. A    Record IDB
  37. ItemB
  38. Date CreatedB
  39. Date ModifiedB
  40. Serial NumberB
  41. CategoryB
  42. Date DueB
  43. Date EndB
  44. Days RentedB
  45. Sunday
  46. Monday
  47. Tuesday
  48.     Wednesday
  49. Thursday
  50. Friday
  51. Saturday
  52. January
  53. February
  54. March
  55. April
  56. August
  57.     September
  58. October
  59. November
  60. December
  61. 1st Quarter
  62. 2nd Quarter
  63. 3rd Quarter
  64. 4th Quarter
  65. 11/20/95
  66. Date StartB
  67. Asset IDB
  68. Customer Order NumB
  69. Don't Count WkndsB
  70. Date End CalcB
  71.       
  72.       
  73.  7) = 0
  74. " - 2
  75.       
  76.  7) = 6
  77. " - 1
  78.       
  79. "2222
  80. Days OverdueB
  81.       
  82.          
  83.             
  84.             
  85. 3) / 7) * 5
  86.             + 
  87.             - 
  88.                
  89.  1904)
  90.                < 
  91.  1904)
  92.               2
  93.               0)
  94.             )
  95.          )
  96.       )
  97.       
  98. 1 + 1
  99.       1 + 
  100. 1) / 7) * 5
  101.       + 
  102.       - 
  103.  1904)
  104.             < 
  105.  1904)
  106.         2
  107.         0)
  108.       )
  109. Date Start CalcB
  110.  7) = 0
  111. ( + 1
  112.  7) = 6
  113. ( + 2
  114. Today CalcB
  115.  7) = 0
  116.  7) = 6
  117. Date Due CalcB
  118.  7) = 0
  119. ! + 1
  120.  7) = 6
  121. ! + 2
  122. Total Days RentedB
  123. InfoB
  124. Created ByB
  125. A    Form View
  126. A    List View
  127. Overdue Rentals
  128. Information
  129. Report Menu
  130. Accumulated Usage
  131. Rental History
  132. A    Form ViewB
  133. Yesfter
  134. Noarter
  135. Yesfter
  136. Noarter
  137. Yesfter
  138. Noarter
  139. Yesfter
  140. Noarter
  141. wwwwww
  142.     ffffff
  143. UUUUUU
  144. DDDDDD
  145. 3333B
  146. """"""
  147. wwxwwxw
  148. ggvgvv
  149. gvwxgwghg
  150. vhgvvww
  151. fvfgfwffv
  152. eVefefe
  153. VvffVefVVefUe\
  154. ffFdeefeefddfDeVdfEdfFdffk
  155. EUeFFEUFEUFFUeTeVFeUUdVEEk
  156. UTdUTeETeETeEUFTUTUFTUUTeK
  157. TEETEETUETUETUDUDEETUDTUE[
  158. 4CDD4E4ET
  159. D4DD4CDDC
  160. C3C3C34C4C3CC43C
  161. "#""3"129
  162. #11#22122"3!
  163. A    List ViewB
  164. Yesfter
  165. Noarter
  166. Yesfter
  167. Noarter
  168. Yesfter
  169. Noarter
  170. Yesfter
  171. Noarter
  172. Yesfter
  173. Noarter
  174. Yesfter
  175. Noarter
  176. Yesfter
  177. Noarter
  178. Yesfter
  179. Noarter
  180. Yesfter
  181. Noarter
  182. Yesfter
  183. Noarter
  184. Yesfter
  185. Noarter
  186. Yesfter
  187. Noarter
  188. Yesfter
  189. Noarter
  190. Your Own
  191. Button
  192. Your Own
  193. Button
  194. Record
  195. Delete
  196. Record
  197. Record
  198. Reports
  199. View As
  200. View As
  201. Close
  202. I    Today is:
  203. Days Rented
  204. Date of Rental End
  205. Days Overdue
  206. Date Due
  207. Customer Order No.
  208. Date of Rental Start
  209. Category
  210. Serial No.
  211. Asset ID
  212. Rental
  213. Rental
  214. X Enter data for Equipment Rentals
  215. Overdue RentalsB
  216. Yesfter
  217. Noarter
  218. Yesfter
  219. Noarter
  220. Yesfter
  221. Noarter
  222. Yesfter
  223. Noarter
  224. Yesfter
  225. Noarter
  226. Yesfter
  227. Noarter
  228. DaysV
  229. StartX    Order No.Y
  230. ItemZ
  231. Asset ID[
  232. Your Own
  233. Button\
  234. Your Own
  235. Button]
  236. Record^
  237. Delete
  238. Record_
  239. Record`
  240. Reportsa
  241. View As
  242. Listb
  243. View As
  244. Formc
  245. Closed
  246. Infoe<Click to see more information for an Equipment Rental record
  247. InformationB
  248. Yesfter
  249. Noarter
  250. Yesfter
  251. Noarter
  252. Yesfter
  253. Noarter
  254. Your Own
  255. Buttono
  256. Reportsp
  257. View As
  258. Listq
  259. View As
  260. Formr
  261. Closes
  262. Infot    Days Overu
  263. Start Datev    Order No.w
  264. Itemx
  265. Asset IDy
  266. Date Duez
  267. Page ##
  268. |"Equipment Rentals; Overdue Rentals
  269. Report MenuB
  270. Your Own
  271. ButtonI
  272. ReportsJ
  273. View As
  274. ListK
  275. View As
  276. FormL
  277. CloseM
  278. InfoO/Information about the Equipment Rental solutionP
  279. Info for this Solution
  280. Your Own
  281. ReportB
  282. Rental HistoryC
  283. Accumulated UsageD
  284. Overdue RentalsE
  285. Your Own
  286. ButtonF
  287. ReportsG
  288. View As
  289. ListH
  290. View As
  291. FormI
  292. CloseJ
  293. InfoK>Click on any of these buttons to preview the respective reportL
  294. Select a report
  295. Accumulated UsageB
  296. Yesfter
  297. Noarter
  298. Yesfter
  299. Noarter
  300. Yesfter
  301. Noarter
  302. Yesfter
  303. Noarter
  304. Your Own
  305. ButtonB
  306. ReportsC
  307. View As
  308. ListD
  309. View As
  310. FormE
  311. CloseF
  312. Rental HistoryB
  313. Yesfter
  314. Noarter
  315. Yesfter
  316. Noarter
  317. Yesfter
  318. Noarter
  319. Yesfter
  320. Noarter
  321. Yesfter
  322. Noarter
  323. Yesfter
  324. Noarter
  325. Your Own
  326. Buttonp
  327. Reportsq
  328. View As
  329. Listr
  330. View As
  331. Forms
  332. Closet
  333. Infou
  334. Days Rentedv
  335. Itemw
  336. Asset IDx
  337. Page ##z$Equipment Rentals; Accumulated Usage
  338. t by Item
  339. Overdue Rentals
  340. Sort by Date of Rental Start
  341. Yesfter
  342. Noarter
  343. Yesfter
  344. Noarter
  345. Yesfter
  346. Noarter
  347. Yesfter
  348. Noarter
  349. Your Own
  350. Buttonu
  351. Reportsv
  352. View As
  353. Listw
  354. View As
  355. Formx
  356. Closey
  357. Infoz
  358. Days{
  359. End Date|
  360. Start Date}    Order No.~
  361. Asset ID, Item
  362. Category
  363. Page ##
  364. C!Equipment Rentals; Rental History
  365. ABCK>>, <<
  366. ABAF>>
  367. Sort by Date of Rental End
  368. Sort by Customer Order Number
  369. Accumulated Usage
  370. Sort for Rental History
  371. Rental History
  372. Open Script
  373. )=400    
  374.     Helvetica
  375. Geneva
  376. Times
  377. Times New Roman
  378. Arial
  379. MS Sans Serif
  380. 4CDD4E4ET
  381. TEETEETUETUETUDUDEETUDTUE[
  382. dUTeETeETeEUFTUTUFTUUTeK
  383. EUeFFEUFEUFFUeTeVFeUUdVEEk
  384. ffFdeefeefddfDeVdfEdfFdffk
  385. eVefefe
  386. VvffVefVVefUe\
  387. fvfgfwffv
  388. ggvgvv
  389. gvwxgwghg
  390. vhgvvww
  391. Cancel
  392. You did not enter any find criteria; all records will be displayed.C)
  393. Cancel
  394. No records match this request.E)
  395. Sort by Asset ID
  396. Sort by Item
  397. Sort by Customer Order Number
  398. Sort by Date of Rental Start
  399. Sort by Date of Rental End
  400. Sort for Rental History
  401. Overdue Rentals
  402. Accumulated Usage
  403. Rental History
  404. Open Script
  405. Sort by Asset ID
  406. Sort by Item
  407. Overdue Rentals
  408. Sort by Date of Rental Start
  409. Ejwwg
  410. wwxwwxw
  411. wwwwww
  412.     ffffff
  413. UUUUUU
  414. DDDDDD
  415. 3333B
  416. """"""
  417. #11#22122"3!
  418. "#""3"129
  419. C3C3C34C4C3CC43C
  420. DDCD4DD4CDDC
  421. 4CDD4E4ET
  422. TEETEETUETUETUDUDEETUDTUE[
  423. dUTeETeETeEUFTUTUFTUUTeK
  424. EUeFFEUFEUFFUeTeVFeUUdVEEk
  425. ffFdeefeefddfDeVdfEdfFdffk
  426. eVefefe
  427. VvffVefVVefUe\
  428. fvfgfwffv
  429. ggvgvv
  430. gvwxgwghg
  431. vhgvvww
  432. (LIST
  433. VDEFA(
  434. (LIST
  435. LISTAPComputers
  436. Office Furniture
  437. Tools - Hand
  438. Tools - Power
  439. Vehicles
  440. Miscellaneous
  441. VDEFA(
  442. (LIST
  443. LISTA
  444. Don't Count Weekends
  445. VDEFA(
  446. A    Item ListB
  447. Category ListC
  448. Don't Count Weekends List
  449. wwwwww
  450.     ffffff
  451. UUUUUU
  452. DDDDDD
  453. wwwwww
  454.     ffffff
  455. UUUUUU
  456. DDDDDD
  457. #4EWp
  458. "4EVx
  459. #3EVg
  460. "4DUg
  461. "#4DVg
  462. 24EVgy
  463. "34EVw
  464. ##4Efw
  465. ""3DUgw
  466. ""33DUfw
  467. ""34DVgx
  468. ""#34EVgx
  469. "#33DEfw
  470. "    234DUfw
  471. 2""2334DEVgx
  472. 3    4DEUfwx
  473. wwffeffg@
  474. veUEDDCC
  475. vUTDD44
  476. vUDDC32
  477. #""# 
  478. weUDD3
  479. veTDC2233#3#2
  480. wUDDC3##"
  481. vUTD3#22
  482. vUDDC
  483. fUD42233##3#"!
  484. vTDCC##"
  485. eUDC3223##
  486. fTD4C3##23#""
  487. uTDC3323#2""!
  488. 22"2"
  489. ##2"!
  490. fTDD33#22""
  491. vUDC32"2""
  492. WUTC22
  493. eTD3#""
  494. GDC32"!!
  495. eD3#"!
  496. T32""
  497. "%UR 
  498. UD33D 
  499. 3    DDUVgw
  500. D    EUUfwx
  501. UDDEUUfgw
  502. U    Vfgwx
  503. eUVfgww
  504. B"#B@
  505. B"#B"$
  506. 4"2$B"#B"#C
  507. 2$""#B"#C0
  508. 4"2#B"#C0
  509. 2$B"D0#C0
  510. 4""#C0
  511. AD@D@
  512. AD@D@
  513. 44444
  514. CCCCC 44444 CCCCC 
  515. $42" 
  516. @@BA@
  517. bRBBP0
  518. UUUUU
  519.  JJJJ
  520. !BBBB
  521. "99BB
  522. #9999
  523. $9911
  524. %1111
  525. &))))C
  526. '!!!!
  527.  *00**-
  528. *00-00 
  529. 00*0)
  530. 00*&0#
  531. ## !0*!%00+#!*0##-0'"0*#%00.!
  532. UUUUUU
  533. wwwwww
  534. (*)(%,3&    
  535. )%+@6) 
  536. ",30,)%
  537.  #*>A6332+$"!
  538. 25,878
  539. #&$690*"
  540. !)0,++)(
  541.  "%/66435/'#
  542. +3;4*=
  543. !#,@9,)+,(""(-/,,*,1!
  544. !$&(265389,#!$$
  545. '275?
  546. $*23/$
  547. $),-..)''
  548. !$&)(-5439@1!!&*-3/)!!%6B)
  549. )220(!$*.,,.' 
  550. !$&*,*023:?B+*.,/3254.'
  551. "++,3/(.584.,"
  552. !#&+/-./3:9@G@60/16883)!
  553. $++//'(9CD>4.$$
  554. $%)*-//2693,.075-&)3792,$
  555. ")-1347<>@G71(!
  556. **)&'*.0350+%(=A2'%)579<94(
  557. +/11!
  558. !%'),342)1?=0)"
  559. .1,$',-01)*).AG6-/048:<H
  560. /2583$%+66/%
  561.  %)++*),+&%06,%$#
  562. !/40')-/31$$,@HFC<6887:==@B7%!
  563. 6A235,% 
  564. +,/13.%#"(16+
  565. !#$(04-$&+,+$
  566. %2>D6,59:989889=0
  567. ,.22<=33*
  568. .22671#
  569. !!&/42&
  570. *1$&+,/3779733,
  571.  $$PQ
  572. /004B6*
  573. !$$ $))'/3)
  574. %&$&.7;4
  575. )2$)*3-)466/%$
  576. !),02+'
  577. %$5)%*+%$!
  578. (+'0:==4
  579. $+,,1643"%)"
  580. !)/1)*+
  581. +7=-%%&$!
  582. !3)3=.
  583. %&*/3113
  584.  !$$PQ
  585. ',4-%)/)
  586. ,6/%$$" 
  587. +(!<-
  588. %),0354-
  589. .13-&,-*
  590. 14'$$! 
  591. %))&%$!
  592. '3*$$" 
  593. !&$%3
  594. &%"%&
  595. 9836'
  596. )&#%%!
  597. $*)++"
  598. .-/:%
  599. !"&)()15,
  600. )" /.-+)!L
  601. //6B&
  602.  #'*,.42$
  603. $/,-*%
  604. IF1A1
  605. "%.2/-*#!
  606. $/.,*($!#$"%PQ
  607. #57-*'$#"$&'
  608. ..//.-,)'(.212PQ
  609. ",,)&%'.;<6/+',,)%!
  610. '//,+//*)+.4:=>PQ
  611. $(&(),5?@:2/,,''*$
  612. -!,,%.0%)./7
  613. #43((+9CA=3+
  614. &*)2!$96;;48@??PQ
  615. )/01%$
  616. #3/').:@<3)$&)!
  617. /)4$%)8=A@?><@PQ
  618. !.0/.+//./1//*
  619. *.').3784/%
  620. ,,#%()25:<99=PQ
  621. %10//O
  622. 0 /+134,.25653."
  623. )++-!
  624. # %0,*,384'%PQ
  625. 42//11/&(/563135650(
  626. (./36$
  627. !"23.,27- 
  628. 6:=<)&931-13-!$.69433563+
  629. ,/258 #$,96-37)$!P
  630. 38;?B>;63/.22.-068934673(
  631. ,638<6$
  632. *),/6."')==138*$)PQ
  633. 35:=@B>953-/1.-368<:8995&
  634. %668:9(
  635. )$'*.:&$*==8/,
  636. -19=@CA>:83+2.,0157:
  637. !""/88$
  638. !)*# 6/0%Q
  639. &' !$*38,.<;60"
  640. +07=@CD=6>@.*)&(*-03;@@<-
  641. 6.3/%
  642. #/23989=2,*%
  643. /039>B@ "9E7,)+/3667:?CE/!"
  644. $$%199207/
  645. 9K8@)
  646. 3933"
  647. !0042381%$(.-)56PQ
  648. 556:=@@
  649. 5C958=BGGA96;='"+-
  650. 94.6BDCFM='(204967&
  651. //2346%
  652. $59232$PQ
  653. :9<@?@C% 6D;;CJLONG952
  654. (9304=FCDDE>%
  655. $,585'
  656. !.//11'$/;81$
  657. 9:CE><D3,5G@@HF>IF94)
  658. $#%+*159C=:>FG)
  659. *31*#
  660. $/51#
  661. 89C=.!:9=C<9AFGS
  662. CA7&(
  663. /%3%!'+5A<6=C>$
  664. -672.3<<961.%!
  665. ,,%=<9/69/02. 
  666. "773//33/,+)
  667. /1$'9<3)"
  668. 069850(*)'%
  669. %/+$ 
  670. !&##34
  671. %0<PQ
  672. %"$:C9.*$
  673. !+6@PQ
  674. "$$6CD>>5
  675. !##()
  676. ".;CPQ
  677.  %'0>GFA:378+&&%$$,&
  678. ,:CPQ
  679. 27CGG@6681//,)%$/
  680. '7CPQ
  681. !%*/1,/44CC;6547@=2*!%.$
  682. %;CPQ
  683. '$)=3
  684.  #%)*())3DLHB
  685. ?MB9/% !
  686. "'6?6$
  687. *;=PQ
  688. $%&,9D6
  689. !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
  690. !)/38;@(
  691. "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
  692. +/0,$%&%%,26:5)
  693. "$%&(/7;<=BGIJIGMG=953'%(1<<63/!
  694. $*.8PQ
  695. 6=@?<3),3:8$
  696. !&((),3=;::=EHIC:<F3)'""#&+/,',
  697. #&(0PQ
  698. FC8:CF@7/08<(
  699. "'()*,169?:6=C=2..3'"
  700. "%&)PQ
  701. HD99=A@9534/
  702. !26(%5, 
  703. ! !),''*-16<@=430/,+/)!
  704. ??979>@@:-!
  705. !$+%-*),/37<@:2/-*)+*" 
  706. 4?=95;@@9&
  707. *#%.,/136884/,)'),,%)+(%$$
  708. />C:13?@9)$ 
  709. !!89+
  710. !)$%*-/13321/,
  711. *3*)-/0/+&$$!
  712.  6A:0,8B=1+)/68.%/(,9=2%
  713. ")$"%)-02331/31)/().241+%##!
  714. *79/)/:<651/33)2<8.6=9. 
  715. !$%,56643/75,'&).340+&#!$$%#!
  716. .5.)/46682%#$$-973:=<7[
  717. !$'+4:964063+(
  718. ,33/+(&'),*)'#
  719. "%%.2379:1&"%(&.36@?@D5 
  720. !$%')/8:86>=2)&!!-231
  721. 34772+*
  722.  &46339C@4+,3/)/:<D/8J='
  723. "%'))+336@3(/)%#%,34569<=?CE5,)!
  724.  #'21\
  725. .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
  726. #,0258<?ADGE2 "'(#
  727. "%),,/6983$
  728. &4<9+4DD>?J>/*-6;<6,,/25.))3,'
  729. ",.0369;=AGE.
  730. !%%(,.040'
  731. 2A?EA4*+/683*.493/($!/-,
  732. 0246689:AC7%
  733. $%##(.23&
  734. :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$
  735. "03., PQ
  736. UUUUUU
  737. wwwwww
  738. Description
  739. This file helps you track rental equipment, such as furniture or computers. It keeps a rental history for each item.
  740. How to use this solution
  741. Use this solution to track current rentals and the rental history of each item. You can run reports detailing overdue rentals and the rental history of each piece. You can also use the reports to complete your taxes.
  742. How to customize this solution
  743. You can change the values in the predefined value list so that the report contains categor
  744. Bies for your types of rental equipment.
  745. You can link the Customer Order No. field to an Invoices database to complete your tracking system. Or, you can add a Customer ID field linked to a Customers database.  Then you could create reports showing which rentals are current and which rentals are overdue for each customer.
  746.